
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.util.List" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.google.appengine.api.rdbms.AppEngineDriver" %>

<html>
  <body>

<%
Connection c = null;
c = DriverManager.getConnection("jdbc:google:rdbms://tomasestasaqui:tomasesta/musica");
ResultSet rs = c.createStatement().executeQuery("SELECT nombre, disco, cancion  FROM artista"); %>

<table style="border: 1px solid black">
<tbody>
<tr>
<th width="35%" style="background-color: #CCFFCC; margin: 5px">Name</th>
<th style="background-color: #CCFFCC; margin: 5px">Message</th>
<th style="background-color: #CCFFCC; margin: 5px">ID</th>
</tr> <%
while (rs.next()){
    String nombre = rs.getString("nombre");
    String disco = rs.getString("disco");
    String cancion = rs.getString("cancion");
      %>

<tr>
<td><%= nombre %></td>
<td><%= disco %></td>
<td><%= cancion %></td>
</tr>

<% }
c.close(); %>

</tbody>

  </body>
</html>